﻿Drop login Nhan
Drop user nhan

Create login Nhan with password = '123' use QuanLyKho
create user Nhan for login nhan

grant all 
on DanhMucHopDong
to nhan

alter login nhan with password = '456'

exec QuanLyKho..sp_addsrvrolemember @loginame = N'nhan', @rolename = N'sysadmin'
exec QuanLyKho..sp_dropsrvrolemember 'admin','sysadmin'

Declare @DonViTinh nvarchar(20)
set @DonViTinh = dbo.func_getDonViTinhMacDinh('NK01')
print @DonViTinh

select * from func_getDanhSachVatTuHangHoa()

